============================================================================== 
Simba ServiceNow ODBC Data Connector Release Notes 
============================================================================== 

The release notes provide details of enhancements, features, known issues, and
workflow changes in Simba ServiceNow ODBC Connector 1.7.8, as well as the
version history. 


1.7.8 ========================================================================

Released 2024-06-26

Enhancements & New Features 

 * [MPH-16278] Updated Ubuntu support

   The connector now supports Ubuntu 24.04 version. For a list of supported 
   platform versions, see the Installation and Configuration Guide.

 * [MPH-16341] Updated FIPS support 

   You can now enable FIPS support by downloading a separate FIPS package 
   available for assistance. For more information, see the Installation and
   Configuration Guide.
 
 * Update on database schemas

   No new database schema are added, modified and decommissioned.
   
   
Known Issues 
The following are known issues that you may encounter due to limitations in 
the data source, the connector, or an application. 

 * The Display schema does not support filter operations.
 
   Only the Actual schema supports filters provided by the ServiceNow Server. 
   Using this schema has better performance for these queries, as only delta
   is fetched.

 * In some cases, if you query data while the EncryptSwapFile property is set
   to 1, the connector might return a corrupted result set.

   When this issue occurs, the returned result set is corrupted, but the 
   original data in the data store is not affected.

   As a potential workaround, do one of the following:
   - Disable swap file creation by setting the MemoryManagerStrategy property 
     to 1. However, be aware that while this setting prevents the connector 
     from returning corrupted result sets, it may also cause some SQL 
     operations on non-SQL data to return out-of-memory errors.
   - If your query does not involve sensitive data, set the EncryptSwapFile 
     property to 0 before running the query. However, be aware that when swap 
     file encryption is disabled, any data that the connector caches in order 
     to support the query is written in plain text.

   For more information about the swap file and memory manager features, see 
   the Installation and Configuration Guide.

 * Power BI performance

   Users may notice decreased performance when using the connector on Power BI
   data.

   This decrease in performance occurs because Power BI creates a 
   relationship structure between tables. Creating this structure requires 
   multiple calls to the connector to retrieve information about the tables..

 * On Windows, the connector cannot use the EncAccessToken setting if the 
   Auth_AccessToken string value exists in the registry key for the DSN.
   
   If the Auth_AccessToken string value exists in the DSN registry key, the
   connector cannot authenticate the connection using the EncAccessToken setting.
   This issue occurs even if there is no value data specified in 
   Auth_AccessToken. As a workaround, delete the Auth_AccessToken string value 
   from your DSN registry key if you want to use the EncAccessToken setting 
   for authentication.   
   
 * Reusing a prepared statement handle may cause a memory leak.

   If a prepared statement handle is used more than once, a memory leak may 
   occur.
   

Workflow Changes =============================================================

The following changes may disrupt established workflows for the connector. 


1.7.8 ------------------------------------------------------------------------

 * [MPH-16297] Removed support for earlier versions of platform

   Beginning with this release, the connector no longer supports the following
   versions of platform:
   - Windows Server 2012r2
   - macOS 10.15
   - CentOS 7
   - Debian 9 and 10
   - Red Hat® Enterprise Linux® (RHEL) 7
  
   For a list of supported platform versions, see the Installation and 
   Configuration Guide.


1.7.6 ------------------------------------------------------------------------

 * Removed support for Visual Studio 2015

   Beginning with this release, support for Visual C++ Redistributable for 
   Visual Studio 2015 has been removed. For supported versions, see the 
   Installation and Configuration Guide.


1.7.2 ------------------------------------------------------------------------

 * Updated UseProxy default value

   The default value for UseProxy is now Disabled (0). Previously, the 
   default value was Enabled (1). For more information, see the Installation
   and Configuration Guide.


1.6.40 -----------------------------------------------------------------------   

 * Removed support for OS platforms

   Beginning with this release, the connector no longer supports the following
   OS platforms: 
   - Windows 7 SP1
   - Windows Server 2008 R2

   For a list of supported OS versions, see the Installation and Configuration
   Guide.

 * Removed support for Visual C++ Redistributable for Visual Studio 2013

   Beginning with this release, the connector no longer supports this version
   of the dependency and requires Visual C++ Redistributable for Visual 
   Studio 2015 instead. For information about the supported Visual C++
   Redistributable for Visual Studio versions, see the Installation and 
   Configuration Guide.   


Version History ==============================================================

1.7.7 ------------------------------------------------------------------------

Released 2024-04-12

Enhancements & New Features 

 * Updated third-party libraries

   The connector now uses the following third-party libraries:
   - Expat 2.6.2 (previously 2.6.0)
   - libcURL 8.7.1 (previously 8.6.0)


1.7.6 ------------------------------------------------------------------------

Released 2024-03-20

Enhancements & New Features

 * Updated third-party libraries

   The connector now uses the following third-party libraries:
   - Expat 2.6.0 (previously 2.5.0)
   - libcURL v8.6.0 (previously 8.4.0)
   - OpenSSL v3.0.13 (previously 3.0.11) 
   - pcre 10.42 (previously 8.45)
   - Poco 1.12.5 (previously 1.12.4)
   - Zlib 1.3.1 (previously 1.2.13)

 * Updated security

   The following compiler and linker flags have been used to improve security
   checks in the connector:  
   - /CETCOMPAT
   - /Qspectre

 * Updated Visual Studio support

   The connector now supports Windows Visual Studio 2022. For supported 
   versions, see the Installation and Configuration Guide.

 * Updated Windows support

   The connector now supports Windows 11 and Windows Server versions 2016, 
   2019, and 2022. For supported Windows versions, see the Installation and
   Configuration Guide.


1.7.5 ------------------------------------------------------------------------

Released 2023-12-18

Enhancements & New Features 

 * Updated OpenSSL support

   The connector now uses OpenSSL 3.0.12. Previously, the connector used 
   OpenSSL 3.0.11.

 * Updated security checks

   Security checks have been added to the connector to improve security.


1.7.4 ------------------------------------------------------------------------

Released 2023-10-23

Enhancements & New Features 

 * Updated third-party libraries

   The connector now uses the following third-party libraries:
   - Libcurl 8.4.0 (previously 8.1.2)
   - OpenSSL 3.0.11 (previously 3.0.9)
   - Pcre 8.45 (previously 8.37)

 * Updated security

   The following compiler and linker flags have been used to improve security
   checks in the connector:  
   - /guard:cf
   - /SDL
   - ZH:SHA_256

 * Updated compiler
  
   The connector now uses macOS 11 ARM Xcode 13.2. For this current release,
   the connector is built using both the new and old (macOS 10_15 Xcode 11_3)
   compiler versions.
   

1.7.3 ------------------------------------------------------------------------

Released 2023-06-19

Enhancements & New Features 

 * Updated third-party libraries

   The connector now uses the following third-party libraries:
   - LibCurl 8.1.2 (previously 7.88.1)
   - OpenSSL 3.0.9 (previously 3.0.8) 


1.7.2 ------------------------------------------------------------------------

Released 2023-05-15

Enhancements & New Features 

 * Internal connector improvements

   The connector has been updated with minor internal improvements.


1.7.1 ------------------------------------------------------------------------

Released 2023-04-03

Enhancements & New Features 

 * Upgraded LibCurl support 

   The connector now uses LibCurl 7.88.1. Previously, the connector used 
   LibCurl 7.87.0.


1.7.0 ------------------------------------------------------------------------

Released 2023-03-10

Enhancements & New Features 

 * Updated third-party libraries

   The connector now uses the following third-party libraries:
   - Expat 2.5.0 (previously 2.4.6)   
   - ICU 71.1.x (previously 58.3.x)
   - LibCurl 7.87 (previously 7.84)
   - OpenSSL 3.0.8 (previously 1.1.1s) 
   - Poco 1.12.4 (previously 1.9.0)
   - Zlib 1.2.13 (previously 1.2.11) 

 * UseProxy support

   The connector can now enable or disable the connection through the proxy 
   server. To do this, select the Use Proxy checkbox (set the UseProxy connection
   property to 1). For more information, see the Installation and Configuration
   Guide.


Resolved Issues
The following issue has been resolved in Simba ServiceNow ODBC connector 
1.7.0.

 * The connector does not identify columns with value as column name from 
   server.


==============================================================================